{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "deletable": true,
    "editable": true
   },
   "source": [
    "## Load Differential Expression from html & write to csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Loaded Differential Expression from html...\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/pkg/python-3.6.0-0/lib/python3.6/site-packages/ipykernel/__main__.py:15: FutureWarning: convert_objects is deprecated.  Use the data-type specific converters pd.to_datetime, pd.to_timedelta and pd.to_numeric.\n"
     ]
    }
   ],
   "source": [
    "def load_diff_expr(file_name_up, file_name_down):\n",
    "    \"\"\"Loads differential up and down-regulated genes.\"\"\"\n",
    "    differential_expression_up = pd.read_html(file_name_up,\n",
    "                                           index_col=2,\n",
    "                                           header=0\n",
    "                                          )[0]\n",
    "    differential_expression_down = pd.read_html(file_name_down,\n",
    "                                               index_col=2,\n",
    "                                               header=0\n",
    "                                               )[0]\n",
    "    print (\"Loaded Differential Expression from html...\")\n",
    "\n",
    "    # concatenate the up and down-regulated genes\n",
    "    differential_expression_down.drop('Ensembl', inplace=True)\n",
    "    differential_expression_down = differential_expression_down.convert_objects(convert_numeric=True)\n",
    "    de = pd.concat([differential_expression_up, differential_expression_down])\n",
    "    return de\n",
    "\n",
    "de = load_diff_expr('../data/differential_expression/DEanalysis/gpp1605-up.html',\n",
    "                    '../data/differential_expression/DEanalysis/gpp1605-down.html'\n",
    "                   )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "de.to_csv('../data/differential_expression/DEanalysis/gpp1605_both.tsv', sep='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>baseMean</th>\n",
       "      <th>log2FoldChange</th>\n",
       "      <th>lfcSE</th>\n",
       "      <th>stat</th>\n",
       "      <th>pvalue</th>\n",
       "      <th>padj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>EBG00001188188</th>\n",
       "      <td>30.799082</td>\n",
       "      <td>8.680116</td>\n",
       "      <td>1.369129</td>\n",
       "      <td>6.339880</td>\n",
       "      <td>2.299442e-10</td>\n",
       "      <td>5.037034e-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EBG00001188189</th>\n",
       "      <td>720.623534</td>\n",
       "      <td>1.693316</td>\n",
       "      <td>0.937678</td>\n",
       "      <td>1.805860</td>\n",
       "      <td>7.094018e-02</td>\n",
       "      <td>1.546084e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EBG00001188191</th>\n",
       "      <td>86.788683</td>\n",
       "      <td>7.652804</td>\n",
       "      <td>1.533542</td>\n",
       "      <td>4.990278</td>\n",
       "      <td>6.029230e-07</td>\n",
       "      <td>6.211332e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EBG00001188194</th>\n",
       "      <td>12.764229</td>\n",
       "      <td>7.997634</td>\n",
       "      <td>3.251754</td>\n",
       "      <td>2.459483</td>\n",
       "      <td>1.391371e-02</td>\n",
       "      <td>4.233814e-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EBG00001188196</th>\n",
       "      <td>5894.283513</td>\n",
       "      <td>11.922721</td>\n",
       "      <td>1.085358</td>\n",
       "      <td>10.985060</td>\n",
       "      <td>4.509378e-28</td>\n",
       "      <td>1.756566e-25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   baseMean  log2FoldChange     lfcSE       stat  \\\n",
       "EBG00001188188    30.799082        8.680116  1.369129   6.339880   \n",
       "EBG00001188189   720.623534        1.693316  0.937678   1.805860   \n",
       "EBG00001188191    86.788683        7.652804  1.533542   4.990278   \n",
       "EBG00001188194    12.764229        7.997634  3.251754   2.459483   \n",
       "EBG00001188196  5894.283513       11.922721  1.085358  10.985060   \n",
       "\n",
       "                      pvalue          padj  \n",
       "EBG00001188188  2.299442e-10  5.037034e-09  \n",
       "EBG00001188189  7.094018e-02  1.546084e-01  \n",
       "EBG00001188191  6.029230e-07  6.211332e-06  \n",
       "EBG00001188194  1.391371e-02  4.233814e-02  \n",
       "EBG00001188196  4.509378e-28  1.756566e-25  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "de = pd.DataFrame.from_csv('../data/differential_expression/deseq2_control_vs_rest.csv').dropna()\n",
    "de.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "source": [
    "## Join differential expression with the network\n",
    "I have differential expression for genes as well as the network. Now, I want to join the two together and obtain a personalization vector (a score for each of the "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "# load gene expression, network and corresponding gene names\n",
    "import h5py\n",
    "fname = '../data/preprocessing/ppi_networks.h5'\n",
    "with h5py.File(fname, 'r') as f:\n",
    "    gene_expression_data = f['gene_expression'][:]\n",
    "    ppi_network = f['consensusPathDB_ppi'][:]\n",
    "    gene_names = f['gene_names'][:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "221 genes in network don't have any differential expression values!\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Gene-name</th>\n",
       "      <th>Node-number</th>\n",
       "      <th>baseMean</th>\n",
       "      <th>log2FoldChange</th>\n",
       "      <th>lfcSE</th>\n",
       "      <th>stat</th>\n",
       "      <th>pvalue</th>\n",
       "      <th>padj</th>\n",
       "      <th>rw_prob</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ENSG00000000003</th>\n",
       "      <td>TSPAN6</td>\n",
       "      <td>0</td>\n",
       "      <td>11.384721</td>\n",
       "      <td>1.086684</td>\n",
       "      <td>0.468817</td>\n",
       "      <td>2.317929</td>\n",
       "      <td>2.045318e-02</td>\n",
       "      <td>5.790401e-02</td>\n",
       "      <td>3.507775e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000000419</th>\n",
       "      <td>DPM1</td>\n",
       "      <td>1</td>\n",
       "      <td>141.003898</td>\n",
       "      <td>1.365080</td>\n",
       "      <td>0.235684</td>\n",
       "      <td>5.791984</td>\n",
       "      <td>6.955993e-09</td>\n",
       "      <td>1.078841e-07</td>\n",
       "      <td>4.633802e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000000457</th>\n",
       "      <td>SCYL3</td>\n",
       "      <td>2</td>\n",
       "      <td>79.981495</td>\n",
       "      <td>0.277552</td>\n",
       "      <td>0.221794</td>\n",
       "      <td>1.251392</td>\n",
       "      <td>2.107914e-01</td>\n",
       "      <td>3.425838e-01</td>\n",
       "      <td>1.561817e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000000938</th>\n",
       "      <td>FGR</td>\n",
       "      <td>3</td>\n",
       "      <td>154.250162</td>\n",
       "      <td>1.396954</td>\n",
       "      <td>0.558959</td>\n",
       "      <td>2.499208</td>\n",
       "      <td>1.244713e-02</td>\n",
       "      <td>3.871257e-02</td>\n",
       "      <td>4.783883e-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000000971</th>\n",
       "      <td>CFH</td>\n",
       "      <td>4</td>\n",
       "      <td>13.584338</td>\n",
       "      <td>-0.379407</td>\n",
       "      <td>0.925138</td>\n",
       "      <td>-0.410108</td>\n",
       "      <td>6.817264e-01</td>\n",
       "      <td>7.827854e-01</td>\n",
       "      <td>8.096862e-07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Gene-name Node-number    baseMean  log2FoldChange     lfcSE  \\\n",
       "ENSG00000000003    TSPAN6           0   11.384721        1.086684  0.468817   \n",
       "ENSG00000000419      DPM1           1  141.003898        1.365080  0.235684   \n",
       "ENSG00000000457     SCYL3           2   79.981495        0.277552  0.221794   \n",
       "ENSG00000000938       FGR           3  154.250162        1.396954  0.558959   \n",
       "ENSG00000000971       CFH           4   13.584338       -0.379407  0.925138   \n",
       "\n",
       "                     stat        pvalue          padj       rw_prob  \n",
       "ENSG00000000003  2.317929  2.045318e-02  5.790401e-02  3.507775e-06  \n",
       "ENSG00000000419  5.791984  6.955993e-09  1.078841e-07  4.633802e-06  \n",
       "ENSG00000000457  1.251392  2.107914e-01  3.425838e-01  1.561817e-06  \n",
       "ENSG00000000938  2.499208  1.244713e-02  3.871257e-02  4.783883e-06  \n",
       "ENSG00000000971 -0.410108  6.817264e-01  7.827854e-01  8.096862e-07  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# add column with node numbers (as in the networkx graph) to the gene names\n",
    "indices = np.arange(0, gene_names.shape[0]).reshape(gene_names.shape[0], 1)\n",
    "gene_names_with_index = np.hstack([gene_names, indices])\n",
    "gene_names_df = pd.DataFrame(gene_names_with_index[:, 1:],\n",
    "                             index=gene_names_with_index[:, 0],\n",
    "                             columns=['Gene-name', 'Node-number']\n",
    "                            )\n",
    "\n",
    "# join gene names and differential expression\n",
    "names_with_de = gene_names_df.join(de, lsuffix='_left')\n",
    "genes_zero_de = names_with_de.log2FoldChange.isnull().sum()\n",
    "print (\"{} genes in network don't have any differential expression values!\".format(genes_zero_de))\n",
    "\n",
    "# calculate random walk probabilities from log2FoldChange\n",
    "names_with_de.ix[names_with_de.log2FoldChange.isnull(), 'log2FoldChange'] = 0\n",
    "def softmax(x):\n",
    "    \"\"\"Compute softmax values for each sets of scores in x.\"\"\"\n",
    "    e_x = np.exp(x - np.max(x))\n",
    "    return e_x / e_x.sum()\n",
    "\n",
    "names_with_de['rw_prob'] = softmax(names_with_de.log2FoldChange)\n",
    "names_with_de.head()\n",
    "\n",
    "# construct dict which can be fed to the networkx pagerank algorithm\n",
    "personalization = {row['Node-number']:row.rw_prob for ens, row in names_with_de.iterrows()}\n",
    "\n",
    "names_with_de.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((9624, 9), (9624, 2), (26878, 6))"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "names_with_de.shape, gene_names_df.shape, de.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "17475 genes in network don't have any differential expression values!\n"
     ]
    }
   ],
   "source": [
    "# add column with node numbers (as in the networkx graph) to the gene names\n",
    "indices = np.arange(0, gene_names.shape[0]).reshape(gene_names.shape[0], 1)\n",
    "gene_names_with_index = np.hstack([gene_names, indices])\n",
    "gene_names_df = pd.DataFrame(gene_names_with_index[:, 1:],\n",
    "                             index=gene_names_with_index[:, 0],\n",
    "                             columns=['Gene-name', 'Node-number']\n",
    "                            )\n",
    "\n",
    "# join gene names and differential expression\n",
    "names_with_de = de.join(names_with_de, lsuffix='_left')\n",
    "genes_zero_de = names_with_de.log2FoldChange.isnull().sum()\n",
    "print (\"{} genes in network don't have any differential expression values!\".format(genes_zero_de))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Gene-type_left</th>\n",
       "      <th>Gene-name_left</th>\n",
       "      <th>baseMean_left</th>\n",
       "      <th>log2FoldChange_left</th>\n",
       "      <th>lfcSE_left</th>\n",
       "      <th>stat_left</th>\n",
       "      <th>pvalue_left</th>\n",
       "      <th>padj_left</th>\n",
       "      <th>Gene-name_left</th>\n",
       "      <th>Node-number</th>\n",
       "      <th>Gene-type</th>\n",
       "      <th>Gene-name</th>\n",
       "      <th>baseMean</th>\n",
       "      <th>log2FoldChange</th>\n",
       "      <th>lfcSE</th>\n",
       "      <th>stat</th>\n",
       "      <th>pvalue</th>\n",
       "      <th>padj</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ensembl</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ENSG00000110172</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CHORDC1</td>\n",
       "      <td>1652.672338</td>\n",
       "      <td>4.377682</td>\n",
       "      <td>0.291540</td>\n",
       "      <td>15.015742</td>\n",
       "      <td>5.791062e-51</td>\n",
       "      <td>2.045238e-47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000162783</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>IER5</td>\n",
       "      <td>4743.970707</td>\n",
       "      <td>5.870139</td>\n",
       "      <td>0.404073</td>\n",
       "      <td>14.527422</td>\n",
       "      <td>8.122010e-48</td>\n",
       "      <td>1.673269e-44</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000184378</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>ACTRT3</td>\n",
       "      <td>80.430582</td>\n",
       "      <td>5.983328</td>\n",
       "      <td>0.488226</td>\n",
       "      <td>12.255238</td>\n",
       "      <td>1.574862e-34</td>\n",
       "      <td>1.441991e-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000163376</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>KBTBD8</td>\n",
       "      <td>725.224687</td>\n",
       "      <td>4.002675</td>\n",
       "      <td>0.327013</td>\n",
       "      <td>12.240117</td>\n",
       "      <td>1.897600e-34</td>\n",
       "      <td>1.675445e-31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000118946</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>PCDH17</td>\n",
       "      <td>49.290006</td>\n",
       "      <td>4.741085</td>\n",
       "      <td>0.435609</td>\n",
       "      <td>10.883804</td>\n",
       "      <td>1.376937e-27</td>\n",
       "      <td>6.947068e-25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000275993</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CH507-42P11.8</td>\n",
       "      <td>235.495664</td>\n",
       "      <td>4.706890</td>\n",
       "      <td>0.439696</td>\n",
       "      <td>10.704882</td>\n",
       "      <td>9.655373e-27</td>\n",
       "      <td>4.420373e-24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000185222</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>WBP5</td>\n",
       "      <td>118.124339</td>\n",
       "      <td>4.548293</td>\n",
       "      <td>0.427704</td>\n",
       "      <td>10.634208</td>\n",
       "      <td>2.065762e-26</td>\n",
       "      <td>9.119600e-24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000144655</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CSRNP1</td>\n",
       "      <td>264.495098</td>\n",
       "      <td>4.555348</td>\n",
       "      <td>0.437198</td>\n",
       "      <td>10.419411</td>\n",
       "      <td>2.022010e-25</td>\n",
       "      <td>7.573961e-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000112149</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CD83</td>\n",
       "      <td>1107.047595</td>\n",
       "      <td>4.552281</td>\n",
       "      <td>0.437363</td>\n",
       "      <td>10.408477</td>\n",
       "      <td>2.268217e-25</td>\n",
       "      <td>8.369381e-23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000142871</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CYR61</td>\n",
       "      <td>32.268183</td>\n",
       "      <td>5.906924</td>\n",
       "      <td>0.574520</td>\n",
       "      <td>10.281489</td>\n",
       "      <td>8.539807e-25</td>\n",
       "      <td>2.852988e-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000123689</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>G0S2</td>\n",
       "      <td>494.090647</td>\n",
       "      <td>3.675446</td>\n",
       "      <td>0.358490</td>\n",
       "      <td>10.252591</td>\n",
       "      <td>1.152126e-24</td>\n",
       "      <td>3.797715e-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000167280</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>ENGASE</td>\n",
       "      <td>161.576559</td>\n",
       "      <td>3.240827</td>\n",
       "      <td>0.320077</td>\n",
       "      <td>10.125138</td>\n",
       "      <td>4.273764e-24</td>\n",
       "      <td>1.372156e-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000113742</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CPEB4</td>\n",
       "      <td>387.764224</td>\n",
       "      <td>2.861859</td>\n",
       "      <td>0.284966</td>\n",
       "      <td>10.042798</td>\n",
       "      <td>9.882998e-24</td>\n",
       "      <td>3.092753e-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000172738</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>TMEM217</td>\n",
       "      <td>31.578399</td>\n",
       "      <td>5.099566</td>\n",
       "      <td>0.511706</td>\n",
       "      <td>9.965813</td>\n",
       "      <td>2.151065e-23</td>\n",
       "      <td>6.256308e-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000089060</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>SLC8B1</td>\n",
       "      <td>303.516252</td>\n",
       "      <td>3.300192</td>\n",
       "      <td>0.332163</td>\n",
       "      <td>9.935453</td>\n",
       "      <td>2.918457e-23</td>\n",
       "      <td>8.389545e-21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000117262</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>GPR89A</td>\n",
       "      <td>358.436811</td>\n",
       "      <td>2.738966</td>\n",
       "      <td>0.280174</td>\n",
       "      <td>9.775944</td>\n",
       "      <td>1.428201e-22</td>\n",
       "      <td>3.756168e-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000111011</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>RSRC2</td>\n",
       "      <td>827.758174</td>\n",
       "      <td>2.346720</td>\n",
       "      <td>0.241277</td>\n",
       "      <td>9.726246</td>\n",
       "      <td>2.330352e-22</td>\n",
       "      <td>5.819290e-20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000187479</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>C11orf96</td>\n",
       "      <td>33.144249</td>\n",
       "      <td>5.522043</td>\n",
       "      <td>0.581533</td>\n",
       "      <td>9.495663</td>\n",
       "      <td>2.188138e-21</td>\n",
       "      <td>5.055622e-19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000132823</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>OSER1</td>\n",
       "      <td>118.684647</td>\n",
       "      <td>2.783735</td>\n",
       "      <td>0.306070</td>\n",
       "      <td>9.095098</td>\n",
       "      <td>9.450099e-20</td>\n",
       "      <td>1.854169e-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000166016</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>ABTB2</td>\n",
       "      <td>209.373840</td>\n",
       "      <td>4.181128</td>\n",
       "      <td>0.460024</td>\n",
       "      <td>9.088938</td>\n",
       "      <td>1.000113e-19</td>\n",
       "      <td>1.931624e-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000168994</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>PXDC1</td>\n",
       "      <td>320.710330</td>\n",
       "      <td>2.250241</td>\n",
       "      <td>0.248009</td>\n",
       "      <td>9.073232</td>\n",
       "      <td>1.155379e-19</td>\n",
       "      <td>2.194276e-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000142149</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>HUNK</td>\n",
       "      <td>21.008524</td>\n",
       "      <td>5.389654</td>\n",
       "      <td>0.594706</td>\n",
       "      <td>9.062722</td>\n",
       "      <td>1.272354e-19</td>\n",
       "      <td>2.382965e-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000234127</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>TRIM26</td>\n",
       "      <td>218.082991</td>\n",
       "      <td>3.509107</td>\n",
       "      <td>0.392221</td>\n",
       "      <td>8.946751</td>\n",
       "      <td>3.661002e-19</td>\n",
       "      <td>6.446887e-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000168005</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>C11orf84</td>\n",
       "      <td>147.730334</td>\n",
       "      <td>2.196237</td>\n",
       "      <td>0.246538</td>\n",
       "      <td>8.908298</td>\n",
       "      <td>5.182174e-19</td>\n",
       "      <td>8.835427e-17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000117519</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CNN3</td>\n",
       "      <td>41.363344</td>\n",
       "      <td>3.806029</td>\n",
       "      <td>0.432045</td>\n",
       "      <td>8.809343</td>\n",
       "      <td>1.258815e-18</td>\n",
       "      <td>2.088620e-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000198929</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>NOS1AP</td>\n",
       "      <td>43.065604</td>\n",
       "      <td>3.802550</td>\n",
       "      <td>0.439587</td>\n",
       "      <td>8.650285</td>\n",
       "      <td>5.137119e-18</td>\n",
       "      <td>7.888189e-16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000168404</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>MLKL</td>\n",
       "      <td>319.612166</td>\n",
       "      <td>2.794845</td>\n",
       "      <td>0.325050</td>\n",
       "      <td>8.598211</td>\n",
       "      <td>8.096818e-18</td>\n",
       "      <td>1.220546e-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000132952</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>USPL1</td>\n",
       "      <td>229.872853</td>\n",
       "      <td>2.354865</td>\n",
       "      <td>0.274273</td>\n",
       "      <td>8.585835</td>\n",
       "      <td>9.017925e-18</td>\n",
       "      <td>1.335979e-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000165312</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>OTUD1</td>\n",
       "      <td>210.206054</td>\n",
       "      <td>3.888043</td>\n",
       "      <td>0.452849</td>\n",
       "      <td>8.585748</td>\n",
       "      <td>9.024694e-18</td>\n",
       "      <td>1.335979e-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000156860</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>FBRS</td>\n",
       "      <td>209.777456</td>\n",
       "      <td>1.897722</td>\n",
       "      <td>0.221611</td>\n",
       "      <td>8.563322</td>\n",
       "      <td>1.096615e-17</td>\n",
       "      <td>1.576193e-15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000206190</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>ATP10A</td>\n",
       "      <td>75.717675</td>\n",
       "      <td>-0.684449</td>\n",
       "      <td>0.340864</td>\n",
       "      <td>-2.007982</td>\n",
       "      <td>4.464524e-02</td>\n",
       "      <td>1.300943e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000146410</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>MTFR2</td>\n",
       "      <td>24.571667</td>\n",
       "      <td>-0.763391</td>\n",
       "      <td>0.380213</td>\n",
       "      <td>-2.007799</td>\n",
       "      <td>4.466463e-02</td>\n",
       "      <td>1.301354e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000203666</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>EFCAB2</td>\n",
       "      <td>27.651012</td>\n",
       "      <td>-0.848596</td>\n",
       "      <td>0.423133</td>\n",
       "      <td>-2.005506</td>\n",
       "      <td>4.490898e-02</td>\n",
       "      <td>1.306188e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000145198</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>VWA5B2</td>\n",
       "      <td>2.850709</td>\n",
       "      <td>-1.377245</td>\n",
       "      <td>0.687153</td>\n",
       "      <td>-2.004278</td>\n",
       "      <td>4.504031e-02</td>\n",
       "      <td>1.308925e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000276966</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>HIST1H4E</td>\n",
       "      <td>254.252700</td>\n",
       "      <td>-0.889431</td>\n",
       "      <td>0.443906</td>\n",
       "      <td>-2.003645</td>\n",
       "      <td>4.510806e-02</td>\n",
       "      <td>1.310413e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000128606</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>LRRC17</td>\n",
       "      <td>3.810902</td>\n",
       "      <td>-1.363749</td>\n",
       "      <td>0.682289</td>\n",
       "      <td>-1.998785</td>\n",
       "      <td>4.563163e-02</td>\n",
       "      <td>1.322670e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000173950</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>XXYLT1</td>\n",
       "      <td>23.747270</td>\n",
       "      <td>-0.734850</td>\n",
       "      <td>0.368469</td>\n",
       "      <td>-1.994334</td>\n",
       "      <td>4.611554e-02</td>\n",
       "      <td>1.333413e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000198870</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>STKLD1</td>\n",
       "      <td>5.497409</td>\n",
       "      <td>-1.161144</td>\n",
       "      <td>0.582259</td>\n",
       "      <td>-1.994205</td>\n",
       "      <td>4.612965e-02</td>\n",
       "      <td>1.333665e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000153157</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>SYCP2L</td>\n",
       "      <td>5.997910</td>\n",
       "      <td>-1.159114</td>\n",
       "      <td>0.581264</td>\n",
       "      <td>-1.994125</td>\n",
       "      <td>4.613845e-02</td>\n",
       "      <td>1.333764e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000185432</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>METTL7A</td>\n",
       "      <td>60.182230</td>\n",
       "      <td>-0.887173</td>\n",
       "      <td>0.445426</td>\n",
       "      <td>-1.991739</td>\n",
       "      <td>4.639971e-02</td>\n",
       "      <td>1.338968e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000166153</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>DEPDC4</td>\n",
       "      <td>4.854774</td>\n",
       "      <td>-1.087092</td>\n",
       "      <td>0.545849</td>\n",
       "      <td>-1.991562</td>\n",
       "      <td>4.641910e-02</td>\n",
       "      <td>1.339058e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000240764</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>PCDHGC5</td>\n",
       "      <td>5.280806</td>\n",
       "      <td>-1.243129</td>\n",
       "      <td>0.625254</td>\n",
       "      <td>-1.988199</td>\n",
       "      <td>4.678968e-02</td>\n",
       "      <td>1.346633e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000203772</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>SPRN</td>\n",
       "      <td>6.330671</td>\n",
       "      <td>-1.143132</td>\n",
       "      <td>0.575153</td>\n",
       "      <td>-1.987526</td>\n",
       "      <td>4.686418e-02</td>\n",
       "      <td>1.348180e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000130653</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>PNPLA7</td>\n",
       "      <td>10.651494</td>\n",
       "      <td>-1.061294</td>\n",
       "      <td>0.535806</td>\n",
       "      <td>-1.980742</td>\n",
       "      <td>4.762016e-02</td>\n",
       "      <td>1.363839e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000196993</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>NPIPB9</td>\n",
       "      <td>3.881107</td>\n",
       "      <td>-1.258679</td>\n",
       "      <td>0.636818</td>\n",
       "      <td>-1.976511</td>\n",
       "      <td>4.809688e-02</td>\n",
       "      <td>1.374532e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000243317</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>C7orf73</td>\n",
       "      <td>82.493068</td>\n",
       "      <td>-0.524810</td>\n",
       "      <td>0.265526</td>\n",
       "      <td>-1.976491</td>\n",
       "      <td>4.809918e-02</td>\n",
       "      <td>1.374532e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000177685</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CRACR2B</td>\n",
       "      <td>16.181254</td>\n",
       "      <td>-0.726637</td>\n",
       "      <td>0.367919</td>\n",
       "      <td>-1.974993</td>\n",
       "      <td>4.826899e-02</td>\n",
       "      <td>1.378111e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000135828</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>RNASEL</td>\n",
       "      <td>83.969696</td>\n",
       "      <td>-0.542301</td>\n",
       "      <td>0.274638</td>\n",
       "      <td>-1.974606</td>\n",
       "      <td>4.831286e-02</td>\n",
       "      <td>1.379045e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000156253</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>RWDD2B</td>\n",
       "      <td>17.268040</td>\n",
       "      <td>-0.811030</td>\n",
       "      <td>0.412020</td>\n",
       "      <td>-1.968423</td>\n",
       "      <td>4.901936e-02</td>\n",
       "      <td>1.394702e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000103047</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>TANGO6</td>\n",
       "      <td>74.941508</td>\n",
       "      <td>-0.425574</td>\n",
       "      <td>0.216231</td>\n",
       "      <td>-1.968142</td>\n",
       "      <td>4.905168e-02</td>\n",
       "      <td>1.395461e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000160352</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>ZNF714</td>\n",
       "      <td>32.396246</td>\n",
       "      <td>-0.639340</td>\n",
       "      <td>0.324880</td>\n",
       "      <td>-1.967928</td>\n",
       "      <td>4.907634e-02</td>\n",
       "      <td>1.395841e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000174501</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>ANKRD36C</td>\n",
       "      <td>267.201298</td>\n",
       "      <td>-0.520222</td>\n",
       "      <td>0.264409</td>\n",
       "      <td>-1.967491</td>\n",
       "      <td>4.912669e-02</td>\n",
       "      <td>1.396631e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000172508</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CARNS1</td>\n",
       "      <td>6.108364</td>\n",
       "      <td>-1.219792</td>\n",
       "      <td>0.620487</td>\n",
       "      <td>-1.965863</td>\n",
       "      <td>4.931439e-02</td>\n",
       "      <td>1.400356e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000151131</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>C12orf45</td>\n",
       "      <td>106.082299</td>\n",
       "      <td>-0.476405</td>\n",
       "      <td>0.242747</td>\n",
       "      <td>-1.962557</td>\n",
       "      <td>4.969762e-02</td>\n",
       "      <td>1.407843e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000150456</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>N6AMT2</td>\n",
       "      <td>13.665238</td>\n",
       "      <td>-0.840257</td>\n",
       "      <td>0.428600</td>\n",
       "      <td>-1.960472</td>\n",
       "      <td>4.994067e-02</td>\n",
       "      <td>1.413271e-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000080293</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>SCTR</td>\n",
       "      <td>0.339541</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.317159</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000149635</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>OCSTAMP</td>\n",
       "      <td>1.221948</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.322045</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000160185</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>UBASH3A</td>\n",
       "      <td>0.229935</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.317054</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000164400</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CSF2</td>\n",
       "      <td>9.486848</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.679724</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ENSG00000189139</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>FSCB</td>\n",
       "      <td>0.161949</td>\n",
       "      <td>-0.175857</td>\n",
       "      <td>0.317054</td>\n",
       "      <td>-0.554658</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1803 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Gene-type_left Gene-name_left  baseMean_left  \\\n",
       "Ensembl                                                         \n",
       "ENSG00000110172  protein_coding        CHORDC1    1652.672338   \n",
       "ENSG00000162783  protein_coding           IER5    4743.970707   \n",
       "ENSG00000184378  protein_coding         ACTRT3      80.430582   \n",
       "ENSG00000163376  protein_coding         KBTBD8     725.224687   \n",
       "ENSG00000118946  protein_coding         PCDH17      49.290006   \n",
       "ENSG00000275993  protein_coding  CH507-42P11.8     235.495664   \n",
       "ENSG00000185222  protein_coding           WBP5     118.124339   \n",
       "ENSG00000144655  protein_coding         CSRNP1     264.495098   \n",
       "ENSG00000112149  protein_coding           CD83    1107.047595   \n",
       "ENSG00000142871  protein_coding          CYR61      32.268183   \n",
       "ENSG00000123689  protein_coding           G0S2     494.090647   \n",
       "ENSG00000167280  protein_coding         ENGASE     161.576559   \n",
       "ENSG00000113742  protein_coding          CPEB4     387.764224   \n",
       "ENSG00000172738  protein_coding        TMEM217      31.578399   \n",
       "ENSG00000089060  protein_coding         SLC8B1     303.516252   \n",
       "ENSG00000117262  protein_coding         GPR89A     358.436811   \n",
       "ENSG00000111011  protein_coding          RSRC2     827.758174   \n",
       "ENSG00000187479  protein_coding       C11orf96      33.144249   \n",
       "ENSG00000132823  protein_coding          OSER1     118.684647   \n",
       "ENSG00000166016  protein_coding          ABTB2     209.373840   \n",
       "ENSG00000168994  protein_coding          PXDC1     320.710330   \n",
       "ENSG00000142149  protein_coding           HUNK      21.008524   \n",
       "ENSG00000234127  protein_coding         TRIM26     218.082991   \n",
       "ENSG00000168005  protein_coding       C11orf84     147.730334   \n",
       "ENSG00000117519  protein_coding           CNN3      41.363344   \n",
       "ENSG00000198929  protein_coding         NOS1AP      43.065604   \n",
       "ENSG00000168404  protein_coding           MLKL     319.612166   \n",
       "ENSG00000132952  protein_coding          USPL1     229.872853   \n",
       "ENSG00000165312  protein_coding          OTUD1     210.206054   \n",
       "ENSG00000156860  protein_coding           FBRS     209.777456   \n",
       "...                         ...            ...            ...   \n",
       "ENSG00000206190  protein_coding         ATP10A      75.717675   \n",
       "ENSG00000146410  protein_coding          MTFR2      24.571667   \n",
       "ENSG00000203666  protein_coding         EFCAB2      27.651012   \n",
       "ENSG00000145198  protein_coding         VWA5B2       2.850709   \n",
       "ENSG00000276966  protein_coding       HIST1H4E     254.252700   \n",
       "ENSG00000128606  protein_coding         LRRC17       3.810902   \n",
       "ENSG00000173950  protein_coding         XXYLT1      23.747270   \n",
       "ENSG00000198870  protein_coding         STKLD1       5.497409   \n",
       "ENSG00000153157  protein_coding         SYCP2L       5.997910   \n",
       "ENSG00000185432  protein_coding        METTL7A      60.182230   \n",
       "ENSG00000166153  protein_coding         DEPDC4       4.854774   \n",
       "ENSG00000240764  protein_coding        PCDHGC5       5.280806   \n",
       "ENSG00000203772  protein_coding           SPRN       6.330671   \n",
       "ENSG00000130653  protein_coding         PNPLA7      10.651494   \n",
       "ENSG00000196993  protein_coding         NPIPB9       3.881107   \n",
       "ENSG00000243317  protein_coding        C7orf73      82.493068   \n",
       "ENSG00000177685  protein_coding        CRACR2B      16.181254   \n",
       "ENSG00000135828  protein_coding         RNASEL      83.969696   \n",
       "ENSG00000156253  protein_coding         RWDD2B      17.268040   \n",
       "ENSG00000103047  protein_coding         TANGO6      74.941508   \n",
       "ENSG00000160352  protein_coding         ZNF714      32.396246   \n",
       "ENSG00000174501  protein_coding       ANKRD36C     267.201298   \n",
       "ENSG00000172508  protein_coding         CARNS1       6.108364   \n",
       "ENSG00000151131  protein_coding       C12orf45     106.082299   \n",
       "ENSG00000150456  protein_coding         N6AMT2      13.665238   \n",
       "ENSG00000080293  protein_coding           SCTR       0.339541   \n",
       "ENSG00000149635  protein_coding        OCSTAMP       1.221948   \n",
       "ENSG00000160185  protein_coding        UBASH3A       0.229935   \n",
       "ENSG00000164400  protein_coding           CSF2       9.486848   \n",
       "ENSG00000189139  protein_coding           FSCB       0.161949   \n",
       "\n",
       "                 log2FoldChange_left  lfcSE_left  stat_left   pvalue_left  \\\n",
       "Ensembl                                                                     \n",
       "ENSG00000110172             4.377682    0.291540  15.015742  5.791062e-51   \n",
       "ENSG00000162783             5.870139    0.404073  14.527422  8.122010e-48   \n",
       "ENSG00000184378             5.983328    0.488226  12.255238  1.574862e-34   \n",
       "ENSG00000163376             4.002675    0.327013  12.240117  1.897600e-34   \n",
       "ENSG00000118946             4.741085    0.435609  10.883804  1.376937e-27   \n",
       "ENSG00000275993             4.706890    0.439696  10.704882  9.655373e-27   \n",
       "ENSG00000185222             4.548293    0.427704  10.634208  2.065762e-26   \n",
       "ENSG00000144655             4.555348    0.437198  10.419411  2.022010e-25   \n",
       "ENSG00000112149             4.552281    0.437363  10.408477  2.268217e-25   \n",
       "ENSG00000142871             5.906924    0.574520  10.281489  8.539807e-25   \n",
       "ENSG00000123689             3.675446    0.358490  10.252591  1.152126e-24   \n",
       "ENSG00000167280             3.240827    0.320077  10.125138  4.273764e-24   \n",
       "ENSG00000113742             2.861859    0.284966  10.042798  9.882998e-24   \n",
       "ENSG00000172738             5.099566    0.511706   9.965813  2.151065e-23   \n",
       "ENSG00000089060             3.300192    0.332163   9.935453  2.918457e-23   \n",
       "ENSG00000117262             2.738966    0.280174   9.775944  1.428201e-22   \n",
       "ENSG00000111011             2.346720    0.241277   9.726246  2.330352e-22   \n",
       "ENSG00000187479             5.522043    0.581533   9.495663  2.188138e-21   \n",
       "ENSG00000132823             2.783735    0.306070   9.095098  9.450099e-20   \n",
       "ENSG00000166016             4.181128    0.460024   9.088938  1.000113e-19   \n",
       "ENSG00000168994             2.250241    0.248009   9.073232  1.155379e-19   \n",
       "ENSG00000142149             5.389654    0.594706   9.062722  1.272354e-19   \n",
       "ENSG00000234127             3.509107    0.392221   8.946751  3.661002e-19   \n",
       "ENSG00000168005             2.196237    0.246538   8.908298  5.182174e-19   \n",
       "ENSG00000117519             3.806029    0.432045   8.809343  1.258815e-18   \n",
       "ENSG00000198929             3.802550    0.439587   8.650285  5.137119e-18   \n",
       "ENSG00000168404             2.794845    0.325050   8.598211  8.096818e-18   \n",
       "ENSG00000132952             2.354865    0.274273   8.585835  9.017925e-18   \n",
       "ENSG00000165312             3.888043    0.452849   8.585748  9.024694e-18   \n",
       "ENSG00000156860             1.897722    0.221611   8.563322  1.096615e-17   \n",
       "...                              ...         ...        ...           ...   \n",
       "ENSG00000206190            -0.684449    0.340864  -2.007982  4.464524e-02   \n",
       "ENSG00000146410            -0.763391    0.380213  -2.007799  4.466463e-02   \n",
       "ENSG00000203666            -0.848596    0.423133  -2.005506  4.490898e-02   \n",
       "ENSG00000145198            -1.377245    0.687153  -2.004278  4.504031e-02   \n",
       "ENSG00000276966            -0.889431    0.443906  -2.003645  4.510806e-02   \n",
       "ENSG00000128606            -1.363749    0.682289  -1.998785  4.563163e-02   \n",
       "ENSG00000173950            -0.734850    0.368469  -1.994334  4.611554e-02   \n",
       "ENSG00000198870            -1.161144    0.582259  -1.994205  4.612965e-02   \n",
       "ENSG00000153157            -1.159114    0.581264  -1.994125  4.613845e-02   \n",
       "ENSG00000185432            -0.887173    0.445426  -1.991739  4.639971e-02   \n",
       "ENSG00000166153            -1.087092    0.545849  -1.991562  4.641910e-02   \n",
       "ENSG00000240764            -1.243129    0.625254  -1.988199  4.678968e-02   \n",
       "ENSG00000203772            -1.143132    0.575153  -1.987526  4.686418e-02   \n",
       "ENSG00000130653            -1.061294    0.535806  -1.980742  4.762016e-02   \n",
       "ENSG00000196993            -1.258679    0.636818  -1.976511  4.809688e-02   \n",
       "ENSG00000243317            -0.524810    0.265526  -1.976491  4.809918e-02   \n",
       "ENSG00000177685            -0.726637    0.367919  -1.974993  4.826899e-02   \n",
       "ENSG00000135828            -0.542301    0.274638  -1.974606  4.831286e-02   \n",
       "ENSG00000156253            -0.811030    0.412020  -1.968423  4.901936e-02   \n",
       "ENSG00000103047            -0.425574    0.216231  -1.968142  4.905168e-02   \n",
       "ENSG00000160352            -0.639340    0.324880  -1.967928  4.907634e-02   \n",
       "ENSG00000174501            -0.520222    0.264409  -1.967491  4.912669e-02   \n",
       "ENSG00000172508            -1.219792    0.620487  -1.965863  4.931439e-02   \n",
       "ENSG00000151131            -0.476405    0.242747  -1.962557  4.969762e-02   \n",
       "ENSG00000150456            -0.840257    0.428600  -1.960472  4.994067e-02   \n",
       "ENSG00000080293             0.000000    0.317159   0.000000           NaN   \n",
       "ENSG00000149635             0.000000    0.322045   0.000000           NaN   \n",
       "ENSG00000160185             0.000000    0.317054   0.000000           NaN   \n",
       "ENSG00000164400             0.000000    0.679724   0.000000           NaN   \n",
       "ENSG00000189139            -0.175857    0.317054  -0.554658           NaN   \n",
       "\n",
       "                    padj_left Gene-name_left Node-number Gene-type Gene-name  \\\n",
       "Ensembl                                                                        \n",
       "ENSG00000110172  2.045238e-47            NaN         NaN       NaN       NaN   \n",
       "ENSG00000162783  1.673269e-44            NaN         NaN       NaN       NaN   \n",
       "ENSG00000184378  1.441991e-31            NaN         NaN       NaN       NaN   \n",
       "ENSG00000163376  1.675445e-31            NaN         NaN       NaN       NaN   \n",
       "ENSG00000118946  6.947068e-25            NaN         NaN       NaN       NaN   \n",
       "ENSG00000275993  4.420373e-24            NaN         NaN       NaN       NaN   \n",
       "ENSG00000185222  9.119600e-24            NaN         NaN       NaN       NaN   \n",
       "ENSG00000144655  7.573961e-23            NaN         NaN       NaN       NaN   \n",
       "ENSG00000112149  8.369381e-23            NaN         NaN       NaN       NaN   \n",
       "ENSG00000142871  2.852988e-22            NaN         NaN       NaN       NaN   \n",
       "ENSG00000123689  3.797715e-22            NaN         NaN       NaN       NaN   \n",
       "ENSG00000167280  1.372156e-21            NaN         NaN       NaN       NaN   \n",
       "ENSG00000113742  3.092753e-21            NaN         NaN       NaN       NaN   \n",
       "ENSG00000172738  6.256308e-21            NaN         NaN       NaN       NaN   \n",
       "ENSG00000089060  8.389545e-21            NaN         NaN       NaN       NaN   \n",
       "ENSG00000117262  3.756168e-20            NaN         NaN       NaN       NaN   \n",
       "ENSG00000111011  5.819290e-20            NaN         NaN       NaN       NaN   \n",
       "ENSG00000187479  5.055622e-19            NaN         NaN       NaN       NaN   \n",
       "ENSG00000132823  1.854169e-17            NaN         NaN       NaN       NaN   \n",
       "ENSG00000166016  1.931624e-17            NaN         NaN       NaN       NaN   \n",
       "ENSG00000168994  2.194276e-17            NaN         NaN       NaN       NaN   \n",
       "ENSG00000142149  2.382965e-17            NaN         NaN       NaN       NaN   \n",
       "ENSG00000234127  6.446887e-17            NaN         NaN       NaN       NaN   \n",
       "ENSG00000168005  8.835427e-17            NaN         NaN       NaN       NaN   \n",
       "ENSG00000117519  2.088620e-16            NaN         NaN       NaN       NaN   \n",
       "ENSG00000198929  7.888189e-16            NaN         NaN       NaN       NaN   \n",
       "ENSG00000168404  1.220546e-15            NaN         NaN       NaN       NaN   \n",
       "ENSG00000132952  1.335979e-15            NaN         NaN       NaN       NaN   \n",
       "ENSG00000165312  1.335979e-15            NaN         NaN       NaN       NaN   \n",
       "ENSG00000156860  1.576193e-15            NaN         NaN       NaN       NaN   \n",
       "...                       ...            ...         ...       ...       ...   \n",
       "ENSG00000206190  1.300943e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000146410  1.301354e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000203666  1.306188e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000145198  1.308925e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000276966  1.310413e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000128606  1.322670e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000173950  1.333413e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000198870  1.333665e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000153157  1.333764e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000185432  1.338968e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000166153  1.339058e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000240764  1.346633e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000203772  1.348180e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000130653  1.363839e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000196993  1.374532e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000243317  1.374532e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000177685  1.378111e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000135828  1.379045e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000156253  1.394702e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000103047  1.395461e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000160352  1.395841e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000174501  1.396631e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000172508  1.400356e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000151131  1.407843e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000150456  1.413271e-01            NaN         NaN       NaN       NaN   \n",
       "ENSG00000080293           NaN            NaN         NaN       NaN       NaN   \n",
       "ENSG00000149635           NaN            NaN         NaN       NaN       NaN   \n",
       "ENSG00000160185           NaN            NaN         NaN       NaN       NaN   \n",
       "ENSG00000164400           NaN            NaN         NaN       NaN       NaN   \n",
       "ENSG00000189139           NaN            NaN         NaN       NaN       NaN   \n",
       "\n",
       "                 baseMean  log2FoldChange  lfcSE  stat  pvalue  padj  \n",
       "Ensembl                                                               \n",
       "ENSG00000110172       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000162783       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000184378       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000163376       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000118946       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000275993       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000185222       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000144655       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000112149       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000142871       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000123689       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000167280       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000113742       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000172738       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000089060       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000117262       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000111011       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000187479       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000132823       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000166016       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000168994       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000142149       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000234127       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000168005       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000117519       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000198929       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000168404       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000132952       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000165312       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000156860       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "...                   ...             ...    ...   ...     ...   ...  \n",
       "ENSG00000206190       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000146410       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000203666       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000145198       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000276966       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000128606       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000173950       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000198870       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000153157       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000185432       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000166153       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000240764       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000203772       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000130653       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000196993       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000243317       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000177685       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000135828       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000156253       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000103047       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000160352       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000174501       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000172508       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000151131       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000150456       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000080293       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000149635       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000160185       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000164400       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "ENSG00000189139       NaN             NaN    NaN   NaN     NaN   NaN  \n",
       "\n",
       "[1803 rows x 18 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "t = names_with_de[names_with_de.log2FoldChange.isnull()]\n",
    "t[t['Gene-type_left'] == 'protein_coding']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Gene-type</th>\n",
       "      <th>Gene-name</th>\n",
       "      <th>baseMean</th>\n",
       "      <th>log2FoldChange</th>\n",
       "      <th>lfcSE</th>\n",
       "      <th>stat</th>\n",
       "      <th>pvalue</th>\n",
       "      <th>padj</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ensembl</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ENSG00000110172</th>\n",
       "      <td>protein_coding</td>\n",
       "      <td>CHORDC1</td>\n",
       "      <td>1652.672338</td>\n",
       "      <td>4.377682</td>\n",
       "      <td>0.29154</td>\n",
       "      <td>15.015742</td>\n",
       "      <td>5.791062e-51</td>\n",
       "      <td>2.045238e-47</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Gene-type Gene-name     baseMean  log2FoldChange  \\\n",
       "Ensembl                                                                  \n",
       "ENSG00000110172  protein_coding   CHORDC1  1652.672338        4.377682   \n",
       "\n",
       "                   lfcSE       stat        pvalue          padj  \n",
       "Ensembl                                                          \n",
       "ENSG00000110172  0.29154  15.015742  5.791062e-51  2.045238e-47  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "de[de['Gene-name'] == 'CHORDC1']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'ENSG00000110172'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m/pkg/python-3.6.0-0/lib/python3.6/site-packages/pandas/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2133\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2134\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2135\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/index.pyx\u001b[0m in \u001b[0;36mpandas.index.IndexEngine.get_loc (pandas/index.c:4433)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/index.pyx\u001b[0m in \u001b[0;36mpandas.index.IndexEngine.get_loc (pandas/index.c:4279)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/src/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas.hashtable.PyObjectHashTable.get_item (pandas/hashtable.c:13742)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/src/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas.hashtable.PyObjectHashTable.get_item (pandas/hashtable.c:13696)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'ENSG00000110172'",
      "\nDuring handling of the above exception, another exception occurred:\n",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-21-5cf58330a190>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mgene_names_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mix\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'ENSG00000110172'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/pkg/python-3.6.0-0/lib/python3.6/site-packages/pandas/core/indexing.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m     85\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     86\u001b[0m             \u001b[0mkey\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcom\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_apply_if_callable\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mobj\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 87\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_axis\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     88\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     89\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_get_label\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlabel\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/pkg/python-3.6.0-0/lib/python3.6/site-packages/pandas/core/indexing.py\u001b[0m in \u001b[0;36m_getitem_axis\u001b[0;34m(self, key, axis)\u001b[0m\n\u001b[1;32m   1030\u001b[0m                     \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0maxis\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1031\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1032\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_label\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0maxis\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1033\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1034\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_getitem_iterable\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/pkg/python-3.6.0-0/lib/python3.6/site-packages/pandas/core/indexing.py\u001b[0m in \u001b[0;36m_get_label\u001b[0;34m(self, label, axis)\u001b[0m\n\u001b[1;32m    100\u001b[0m             \u001b[0;32mraise\u001b[0m \u001b[0mIndexingError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'no slices here, handle elsewhere'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    101\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 102\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mobj\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_xs\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlabel\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0maxis\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    103\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    104\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_get_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/pkg/python-3.6.0-0/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36mxs\u001b[0;34m(self, key, axis, level, drop_level)\u001b[0m\n\u001b[1;32m   1777\u001b[0m                                                       drop_level=drop_level)\n\u001b[1;32m   1778\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1779\u001b[0;31m             \u001b[0mloc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1780\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1781\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mloc\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mndarray\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/pkg/python-3.6.0-0/lib/python3.6/site-packages/pandas/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2134\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2135\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2136\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_maybe_cast_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2137\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2138\u001b[0m         \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtolerance\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mtolerance\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/index.pyx\u001b[0m in \u001b[0;36mpandas.index.IndexEngine.get_loc (pandas/index.c:4433)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/index.pyx\u001b[0m in \u001b[0;36mpandas.index.IndexEngine.get_loc (pandas/index.c:4279)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/src/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas.hashtable.PyObjectHashTable.get_item (pandas/hashtable.c:13742)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/src/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas.hashtable.PyObjectHashTable.get_item (pandas/hashtable.c:13696)\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'ENSG00000110172'"
     ]
    }
   ],
   "source": [
    "gene_names_df.ix['ENSG00000110172']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
